home *** CD-ROM | disk | FTP | other *** search
/ Collection of Tools & Utilities / Collection of Tools and Utilities.iso / clipper / cgwrka10.zip / INP_DEMO < prev    next >
Text File  |  1993-11-13  |  3KB  |  140 lines
  1. WINDOW W_PERSON
  2.  
  3. Comments:
  4. PERSON BASIC DATA, 30, 6
  5. cm, 40, 15
  6.  
  7. Tables:
  8. people, 1
  9. town, 5, No_add, No_upd, No_del, , 1
  10. car, 10, No_add, No_upd, No_del
  11.  
  12. Arrays:
  13. people->name, 2, NAME, 30, 8, ,Req_add, , , "AAA", @!
  14. people->surname, 3, SURNAME, 27, 9, , Req_add, , , , @!
  15. people->ident, 4, UNIQ IDENT, 24, 10, unique
  16. town->town,2, BORN TOWN, 14, 12, , Req_add, , , , , , , , (10;10;30;20;;town;2)
  17. people->born_date, 5, BORN DATE, 14, 13, , Req_add, , , "today", @D, , val_not_futur, , , , H1
  18. town1->town,2, LIVE TOWN, 40, 12, , Req_add, , , , , , , , (10;10;30;20;;town;2)
  19. people->tall, 8, TALL, 28, 15, , , , , , , 40-250
  20. car->id_no,2, CAR NO., 27, 16, , Req_add, , , , , , check_car, , (10;10;30;20;ins_c;car;2;3)
  21. car->type,3, CAR TYPE, 26, 17, , Req_add, , , , , , , , (10;10;30;20;ins_c;car;3;2)
  22. people->p_memo,10, MEMO, 30, 18
  23. people->p_ind,1, , -1, -1, unique
  24. town->t_ind,1, , -1, -1
  25. town1->t_ind,1, , -1, -1
  26. people->born_town,6, , -1, -1
  27. people->live_town,7, , -1, -1
  28. people->c_ind,9, unique, -1, 0
  29. car->c_ind,1, , -1, -1
  30.  
  31. Links:
  32. people->born_town = town->t_ind
  33. people->live_town = town1->t_ind
  34. people->c_ind = car->c_ind
  35.  
  36. Lines:
  37. 7,5,77,22
  38. people->name
  39. people->surname
  40. town->town
  41. people->born_date
  42. town1->town
  43.  
  44. Return:
  45. people->name
  46. people->surname
  47.  
  48. Help:
  49. H0;10;10;40;20
  50. You can search on every field.
  51. etc
  52. etc
  53. H1;20;10;40;20
  54. Date must be lower or equal today date.
  55.  
  56. WINDOW W_PARENT
  57.  
  58. Comments:
  59. PARENTS DATA FOR CHILDREN, 20, 6
  60.  
  61. Tables:
  62. people,1, No_add, , No_del, , 2
  63.  
  64. Arrays:
  65. people->name,2, NAME, 33, 8, , , , , , , , , , (10;10;70;20;ins_p;people;2;3;5)
  66. people->surname,3, SURNAME, 30, 9, , , , , , , , , , (10;10;70;20;ins_p;people;3;2;5)
  67. people1->name,2, FATHER NAME, 10, 11, , , , , , , , , , (10;10;70;20;ins_p;people;2;3;5)
  68. people1->surname,3, SURNAME, 14, 12, , , , , , , , , , (10;10;70;20;ins_p;people;3;2;5)
  69. people2->name,2, MOTHER NAME, 40, 11, , , , , , , , , , (10;10;70;20;ins_p;people;2;3;5)
  70. people2->surname,3, SURNAME, 44, 12, , , , , , , , , , (10;10;70;20;ins_p;people;3;2;5)
  71. people->fath_ind,11, , -1, -1
  72. people->moth_ind,12, , -1, -1
  73. people1->p_ind,1, , -1, -1
  74. people2->p_ind,1, , -1, -1
  75.  
  76. Links:
  77. people->fath_ind = people1->p_ind
  78. people->moth_ind = people2->p_ind
  79.  
  80. Lines:
  81. 10,5,70,22
  82. people->name
  83. people->surname
  84. people1->name
  85. people2->name
  86.  
  87. Return:
  88.  
  89. Help:
  90.  
  91. WINDOW W_TOWN
  92.  
  93. Comments:
  94. TOWN DATA, 35, 6
  95.  
  96. Tables:
  97. town,5
  98.  
  99. Arrays:
  100. town->town,2, NAME, 30, 8
  101. town->t_memo,3, MEMO, 30, 10, , , , , , , , , , , (30;12;45;20), H1
  102. town->t_ind,1, , -1, -1, unique
  103.  
  104. Links:
  105.  
  106. Lines:
  107. 10,5,70,22
  108. town->town
  109.  
  110. Return:
  111.  
  112. Help:
  113. H1;30;17;45;24
  114. Press any character and return to get window for memo field.
  115.  
  116. WINDOW W_CAR
  117.  
  118. Comments:
  119. CAR DATA, 35, 6
  120.  
  121. Tables:
  122. car,10
  123.  
  124. Arrays:
  125. car->id_no,2, CAR NO., 30, 8, unique
  126. car->type,3, CAR TYPE, 30, 10, , Req_add
  127. car->c_memo,4, MEMO, 34, 11
  128. car->c_ind,1, , -1, -1, unique
  129.  
  130. Links:
  131.  
  132. Lines:
  133. 10,5,70,22
  134. car->id_no
  135. car->type
  136.  
  137. Return:
  138.  
  139. Help:
  140.